﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
 
namespace mpsalary
{
    public partial class Chart : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection();
            SqlCommand comm = new SqlCommand();

            conn.ConnectionString = ConfigurationManager.ConnectionStrings["dbConn"].ToString();
            conn.Open();

            comm.Connection = conn;
            comm.CommandText = "SELECT Distinct Course FROM Wages";
            SqlDataReader dr = comm.ExecuteReader();
            while (dr.Read())
            {
                Courses1DropDownList.Items.Add(dr["Course"].ToString());
                Courses2DropDownList.Items.Add(dr["Course"].ToString());
                Courses3DropDownList.Items.Add(dr["Course"].ToString());

            } 


        } 

        protected void imagebtnHome_Click(object sender, ImageClickEventArgs e)
        {
            Response.Redirect("signup.aspx");
        }
    }
}